home *** CD-ROM | disk | FTP | other *** search
/ Windows 95 API Bible / Windows 95 API Bible 3 Disc Set.iso / Win32 API Bible Book 3 of 3.iso / chapter7 / moreres.c < prev    next >
C/C++ Source or Header  |  1996-03-24  |  10KB  |  287 lines
  1.  
  2. #include <windows.h>  
  3. #include "moreres.h"
  4. #include "sqlext.h"  
  5.  
  6.  
  7. #if defined (WIN32)
  8.     #define IS_WIN32 TRUE
  9. #else
  10.     #define IS_WIN32 FALSE
  11. #endif
  12.  
  13. #define IS_NT      IS_WIN32 && (BOOL)(GetVersion() < 0x80000000)
  14. #define IS_WIN32S  IS_WIN32 && (BOOL)(!(IS_NT) && (LOBYTE(LOWORD(GetVersion()))<4))
  15. #define IS_WIN95   (BOOL)(!(IS_NT) && !(IS_WIN32S)) && IS_WIN32
  16.  
  17. HINSTANCE hInst;   // current instance
  18.  
  19. LPCTSTR lpszAppName = "MyApp";
  20. LPCTSTR lpszTitle   = "SQLMoreResults()"; 
  21.  
  22.  
  23. BOOL RegisterWin95( CONST WNDCLASS* lpwc );
  24.  
  25.  
  26. int APIENTRY WinMain( HINSTANCE hInstance, HINSTANCE hPrevInstance,
  27.                       LPTSTR lpCmdLine, int nCmdShow)
  28. {
  29.    MSG      msg;
  30.    HWND     hWnd; 
  31.    WNDCLASS wc;
  32.  
  33.    wc.style         = CS_HREDRAW | CS_VREDRAW;
  34.    wc.lpfnWndProc   = (WNDPROC)WndProc;       
  35.    wc.cbClsExtra    = 0;                      
  36.    wc.cbWndExtra    = 0;                      
  37.    wc.hInstance     = hInstance;              
  38.    wc.hIcon         = LoadIcon (hInstance, lpszAppName); 
  39.    wc.hCursor       = LoadCursor(NULL, IDC_ARROW);
  40.    wc.hbrBackground = (HBRUSH)(COLOR_WINDOW+1);
  41.    wc.lpszMenuName  = lpszAppName;              
  42.    wc.lpszClassName = lpszAppName;              
  43.  
  44.    if ( IS_WIN95 )
  45.    {
  46.       if ( !RegisterWin95( &wc ) )
  47.          return( FALSE );
  48.    }
  49.    else if ( !RegisterClass( &wc ) )
  50.       return( FALSE );
  51.  
  52.    hInst = hInstance; 
  53.  
  54.    hWnd = CreateWindow( lpszAppName, 
  55.                         lpszTitle,    
  56.                         WS_OVERLAPPEDWINDOW, 
  57.                         CW_USEDEFAULT, 0, 
  58.                         CW_USEDEFAULT, 0,  
  59.                         NULL,              
  60.                         NULL,              
  61.                         hInstance,         
  62.                         NULL               
  63.                       );
  64.  
  65.    if ( !hWnd ) 
  66.       return( FALSE );
  67.  
  68.    ShowWindow( hWnd, nCmdShow ); 
  69.    UpdateWindow( hWnd );         
  70.  
  71.    while( GetMessage( &msg, NULL, 0, 0) )   
  72.    {
  73.       TranslateMessage( &msg ); 
  74.       DispatchMessage( &msg );  
  75.    }
  76.  
  77.    return( msg.wParam ); 
  78. }
  79.  
  80.  
  81. BOOL RegisterWin95( CONST WNDCLASS* lpwc )
  82. {
  83.    WNDCLASSEX wcex;
  84.  
  85.    wcex.style         = lpwc->style;
  86.    wcex.lpfnWndProc   = lpwc->lpfnWndProc;
  87.    wcex.cbClsExtra    = lpwc->cbClsExtra;
  88.    wcex.cbWndExtra    = lpwc->cbWndExtra;
  89.    wcex.hInstance     = lpwc->hInstance;
  90.    wcex.hIcon         = lpwc->hIcon;
  91.    wcex.hCursor       = lpwc->hCursor;
  92.    wcex.hbrBackground = lpwc->hbrBackground;
  93.    wcex.lpszMenuName  = lpwc->lpszMenuName;
  94.    wcex.lpszClassName = lpwc->lpszClassName;
  95.  
  96.    // Added elements for Windows 95.
  97.    //...............................
  98.    wcex.cbSize = sizeof(WNDCLASSEX);
  99.    wcex.hIconSm = LoadImage(wcex.hInstance, lpwc->lpszClassName, 
  100.                             IMAGE_ICON, 16, 16,
  101.                             LR_DEFAULTCOLOR );
  102.             
  103.    return RegisterClassEx( &wcex );
  104. }
  105.  
  106.  
  107. UCHAR  szSqlStr[]    = "Select dept_id, dept_name, dept_head_id From department where dept_id = ?";
  108. SDWORD cbValues[]    = { SQL_NTS, SQL_NTS, SQL_NTS };
  109. UCHAR  szValues[][4] = { "300", "100", "500" };
  110.  
  111. LRESULT CALLBACK WndProc( HWND hWnd, UINT uMsg, WPARAM wParam, LPARAM lParam )
  112. {
  113. static HENV  hEnv  = NULL;
  114. static HDBC  hDBC  = NULL;
  115. static HWND  hList = NULL;
  116.  
  117.    switch( uMsg )
  118.    {
  119.       case WM_CREATE :
  120.               {
  121.                  RETCODE retCode;
  122.  
  123.                  // Allocate Environment and Connection.
  124.                  //.....................................
  125.                  SQLAllocEnv( &hEnv );
  126.                  SQLAllocConnect( hEnv, &hDBC );
  127.  
  128.                  // Connect to the data source.
  129.                  //............................
  130.                  retCode = SQLDriverConnect( hDBC, hWnd, NULL, SQL_NTS, 
  131.                                              NULL, 0, NULL, SQL_DRIVER_PROMPT );
  132.  
  133.                  if ( retCode != SQL_SUCCESS && retCode != SQL_SUCCESS_WITH_INFO )
  134.                  {
  135.                     SQLFreeConnect( hDBC );
  136.                     SQLFreeEnv( hEnv );
  137.                     return( -1 );
  138.                  }
  139.                  else
  140.                  {
  141.                     int nTabSize = 40;
  142.  
  143.                     hList = CreateWindow( "LISTBOX", "",    
  144.                                LBS_NOTIFY | LBS_USETABSTOPS |
  145.                                LBS_NOINTEGRALHEIGHT  | 
  146.                                WS_BORDER  | WS_CHILD | 
  147.                                WS_VISIBLE | WS_VSCROLL, 
  148.                                0, 0, 0, 0, 
  149.                                hWnd, (HMENU)101,
  150.                                hInst, NULL );
  151.                     
  152.                     SendMessage( hList, LB_SETTABSTOPS, 1, (LPARAM)&nTabSize );
  153.                  }
  154.               }
  155.               break;
  156.  
  157.       case WM_SIZE :
  158.               MoveWindow( hList, 0, 0, LOWORD( lParam ), 
  159.                                        HIWORD( lParam ), TRUE );
  160.               break; 
  161.               
  162.       case WM_COMMAND :
  163.               switch( LOWORD( wParam ) )
  164.               {
  165.                  case IDM_TEST :
  166.                         {
  167.                            HSTMT   hStmt;
  168.                            UCHAR   szDeptId    [32];
  169.                            UCHAR   szDeptName  [32];
  170.                            UCHAR   szDeptHeadId[32];
  171.                            UCHAR   szLBStr     [128];
  172.                            SDWORD  dwTypeLen;
  173.                            UDWORD  dwRow;
  174.                            RETCODE retCode;
  175.  
  176.                            SQLAllocStmt( hDBC, &hStmt );
  177.  
  178.                            // Set the number of parameters in our array.
  179.                            //...........................................
  180.                            SQLBindParameter( hStmt, 1, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_CHAR,
  181.                                                    4, 0, szValues, 0, cbValues );
  182.  
  183.                            SQLParamOptions( hStmt, 3, &dwRow );
  184.                            SQLPrepare( hStmt, szSqlStr, SQL_NTS);
  185.  
  186.                            // Bind columns for output.
  187.                            //.........................
  188.                            SQLBindCol( hStmt, 1, SQL_C_CHAR, szDeptId, 
  189.                                        sizeof( szDeptId ), &dwTypeLen );
  190.                            SQLBindCol( hStmt, 2, SQL_C_CHAR, szDeptName, 
  191.                                        sizeof( szDeptName ), &dwTypeLen );
  192.                            SQLBindCol( hStmt, 3, SQL_C_CHAR, szDeptHeadId, 
  193.                                        sizeof( szDeptHeadId ), &dwTypeLen );
  194.  
  195.                            // Call SQLExecDirect() to execute the query.
  196.                            // ..........................................
  197.                            retCode = SQLExecute( hStmt );
  198.  
  199.                            // Call SQLExecute() to execute the query.
  200.                            // .......................................
  201.                            while ( retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO )
  202.                            {
  203.                               // Call SQLFetch() to retrieve data 
  204.                               // from the rowset, one row at a time.
  205.                               // ...................................
  206.                               retCode = SQLFetch( hStmt );
  207.                               while ( retCode == SQL_SUCCESS )
  208.                               {
  209.                                  szLBStr[0] = '\0';
  210.                                  strcat( szLBStr, szDeptId );
  211.                                  strcat( szLBStr, "\t" );
  212.                                  strcat( szLBStr, szDeptName );
  213.                                  strcat( szLBStr, "\t" );
  214.                                  strcat( szLBStr, szDeptHeadId );
  215.  
  216.                                  SendMessage( hList, LB_ADDSTRING, 0, (LPARAM)szLBStr );
  217.                                  retCode = SQLFetch( hStmt );
  218.                               }
  219.  
  220.                               retCode = SQLMoreResults( hStmt );
  221.                               if ( retCode == SQL_SUCCESS )
  222.                               {
  223.                                  szDeptId[0] = '\0';
  224.                                  szDeptName[0] = '\0';
  225.                                  szDeptHeadId[0] = '\0';
  226.                               }
  227.                            }
  228.  
  229.                            // Free the statement handle.
  230.                            // ..........................
  231.                            SQLFreeStmt( hStmt, SQL_DROP );
  232.                         }
  233.                         break;
  234.  
  235.                  case IDM_ABOUT :
  236.                         DialogBox( hInst, "AboutBox", hWnd, (DLGPROC)About );
  237.                         break;
  238.  
  239.                  case IDM_EXIT :
  240.                         DestroyWindow( hWnd );
  241.                         break;
  242.               }
  243.               break;
  244.       
  245.       case WM_DESTROY :
  246.               PostQuitMessage(0);
  247.  
  248.               // Disconnect Environment.
  249.               //........................
  250.               SQLDisconnect( hDBC );
  251.  
  252.               // Free Connection and Environment.
  253.               //.................................
  254.               SQLFreeConnect( hDBC );
  255.               SQLFreeEnv( hEnv );
  256.               break;
  257.  
  258.       default :
  259.             return( DefWindowProc( hWnd, uMsg, wParam, lParam ) );
  260.    }
  261.  
  262.    return( 0L );
  263. }
  264.  
  265. LRESULT CALLBACK About( HWND hDlg,           
  266.                         UINT message,        
  267.                         WPARAM wParam,       
  268.                         LPARAM lParam)
  269. {
  270.    switch (message) 
  271.    {
  272.        case WM_INITDIALOG: 
  273.                return (TRUE);
  274.  
  275.        case WM_COMMAND:                              
  276.                if (   LOWORD(wParam) == IDOK         
  277.                    || LOWORD(wParam) == IDCANCEL)    
  278.                {
  279.                        EndDialog(hDlg, TRUE);        
  280.                        return (TRUE);
  281.                }
  282.                break;
  283.    }
  284.  
  285.    return (FALSE); 
  286. }
  287.